--ALTER TABLE so ADD cPromo VARCHAR (15) NULL
--ALTER TABLE so ADD cWHMan VARCHAR (15) NULL

--ALTER TABLE client_customer ADD cConsigneeID VARCHAR (15) NULL
--ALTER TABLE client_customer ADD cConCollect VARCHAR (50) NULL

--ALTER TABLE wrr ALTER COLUMN cTerms VARCHAR (15) NULL
--ALTER TABLE [dbo].[wrr] ALTER COLUMN [cTerms] [varchar](25) NULL

--UPDATE client_customer
--SET cTIN = '000-657-059-000',
--	cConsigneeID = '3864 15'
----SELECT * FROM client_customer 
--WHERE cCode LIKE 'sm%'

select cItemNo as id, ISNULL((cDesc + '/' + cGroup1),cDesc) as description
  from item WHERE cItemNo = 'HL902L'